VLookup in Excel Part 1 | VLOOKUP सिर्फ़ 30 minute में (हिंदी) Excel Lecture 4 | Neeraj Arora

Поделиться
HTML-код
  • Опубликовано: 21 дек 2024

Комментарии • 1,3 тыс.

  • @ExcelforBeginners
    @ExcelforBeginners  3 года назад +47

    🔥 Learn & Master Excel With 3500+ Students Across India on Excel Club 🔥
    Link: www.skill91.com/s/store/courses/description/Excel-Club

    • @MWAIslamicStudio
      @MWAIslamicStudio 3 года назад +3

      I am in Dubai, I can't join excel club, indian number not working here so I added dubai number, now 4 digit code not received, what is the solution

    • @abhesinh0027
      @abhesinh0027 2 года назад

      @@MWAIslamicStudio arasS sa ddzx*Xx Dd

    • @RT-yv7ev
      @RT-yv7ev 2 года назад +3

      Salute you sir, i know V lookup but your teaching skill is excellent with depth knowledge

    • @RT-yv7ev
      @RT-yv7ev 2 года назад +1

      Ek video pivot table pe b dekhna chahunga sir🤗

    • @poonamshukla3639
      @poonamshukla3639 2 года назад +1

      Kahan se khoju vlookup

  • @heenarehman9106
    @heenarehman9106 4 года назад +17

    Very helpful , everytime interviewer ask me about vlookup and i alwyz said that i dont know how to use.. but now i can say yes i know what is vlookup and how to use it.
    Thank you

  • @AnmolKumar-wd1rv
    @AnmolKumar-wd1rv Год назад +80

    video starts from 03:84, thank me later.....

  • @beingachildalways
    @beingachildalways 5 лет назад +23

    Finally is vedio ko dekh kr seriously samjh m aya vlookup itna asan h.....this is it

  • @mohandekate2282
    @mohandekate2282 3 года назад +2

    sir aapka tarika shandar h . me kabhi kisi video pr comment nhi krta pr is video ne comment krne pr majbur kr diya h ... i salute you

  • @tushanarora1413
    @tushanarora1413 5 лет назад +92

    Sir, most of the time people make jokes on this but today you proved that this line is not a joke and make this a reality that "sirf naam hi kaafi hai". whole CA family trust u to that extent that as this channel is of Neeraj sir then every video is worth to watch and every time u give more then the expectations. Thank u so much sir.. Respect for u always from heart..!

  • @Pawanddaz
    @Pawanddaz 4 года назад +1

    I have watched many videos for vlookup formula. I saw many videos but I can say this was the best video I found on youtube. Thank you so much sir for this amazing video of lookup for formula. I can easily now use vlookup formula.

  • @afreenm0309
    @afreenm0309 5 лет назад +4

    I had learnt VLOOKUP 2-3 days back.... But saw your full vedio because i knew I will learn something more and GUESS WHAT.. i learnt it and that was APPROX MATCH...

  • @vinaymandal9891
    @vinaymandal9891 2 года назад +1

    Jitna in sir ka padhane ka style acha hai itna to tution mei achi fees dene k bad bhi koi nahi batata hai. hats of you and your education skills sir.

  • @supersid1043
    @supersid1043 3 года назад +3

    it was really helpful to understand the concept. I tried practical use of it and without any mistake I separated some data from large data file.

  • @VasnaniHarish
    @VasnaniHarish 4 года назад

    DEAR SIR
    I DONE INVOICE THRU VLOOKUP FIRST TIME AND I DONE SUCCESSFUL I WATCH MORE THEN FIVE TIME YOUR METHOD IS VERY EASY AND UNDERSTAND. THANKS A LOT
    NOW I WILL TRY XLOOKUP LETS SEE

  • @learntoadjust7352
    @learntoadjust7352 4 года назад +10

    Extremely nice explanation. It cleared all of my doubts..
    Thank you very much for his wonderful contribution in society !

  • @m_jay4608
    @m_jay4608 2 года назад

    to be honest i dont know anything about vlookup but thnx to this video ive learned alot about vlookup.... brother you're doing good.... million thanks to you man..... im having excel test for my job interview process tomorrow and u helped me alot.... kudos to you..... lots of love brother..... god bless my man

  • @manishadreamcorner1517
    @manishadreamcorner1517 3 года назад +4

    Superb! Awesome!. I understood vlookup from you. I have checked other videos also. But your way of explaining and understanding that we are bigineers was outstanding. But aap ye excel share karte to aur maza aa jata

  • @rahuljadhav7858
    @rahuljadhav7858 4 года назад +2

    Aaji L mere content real content to ye Hain sir there so many teachers who teaching VLookup but but no one teaching like you your teaching like elder brother (Jo Puri imandari k Saath sikhta h) thanks a lot for giving such solid content.💜

  • @minhajcommunication2398
    @minhajcommunication2398 4 года назад +18

    I think u should also give the link of data on description for our practice .
    That will be more beneficial for us

  • @Baisoya007
    @Baisoya007 2 года назад

    I have seen so many video about vlookup but nobody better than you...most important I'm confusing abt F4 and you clear my doubt so well

    • @chiragaggarwal5544
      @chiragaggarwal5544 2 года назад

      bhai F4 wala key se ho hi rha hai kuch or range wala kya hai smj hi nhi aaya smja skte ho.

  • @brgplanet
    @brgplanet 2 года назад +5

    The way of teaching vlookup is far better than other videos which I had seen. Really did good job here. I have finally understood the proper use of Vlookup Sir ji. Thankyou for making this video for us. 😀

  • @sujitkurhade4128
    @sujitkurhade4128 3 года назад

    Professionals(CA, CMA, CS) logo ki baat kuch alag hoti hai... Very sir

  • @santosh22880
    @santosh22880 4 года назад +11

    Easy to Learn, Easy to Understand and Fun while learning, keep going Sir, thank you.

  • @preetigupta2506
    @preetigupta2506 4 года назад

    Thank you sir mene kafi videos dekhi h excel se related but apke samjhne ka tarika bahut achha hai....

  • @life-oc5jt
    @life-oc5jt 4 года назад +16

    The way of u teaching us , its really very interesting and easy to learn 👏

  • @ShankarSandesh
    @ShankarSandesh 3 года назад +1

    बहुत अच्छा विडीओ बनाया है भैया आपने!
    इस विडीओ से सीखने को मिला।

  • @smartymukherjeeforconsulti3282
    @smartymukherjeeforconsulti3282 4 года назад +4

    Awesome tutorial, thanks for sharing. Your way of teaching is very interesting

  • @factofmumbaikar9371
    @factofmumbaikar9371 Год назад

    At the starting of the video. I thought , he is just promoting the brands , but when i watched the full video , i would like to say that , I invested my time in the right place.# thankyou so much sir for the video❤

  • @ishashah1197
    @ishashah1197 4 года назад +10

    I don't think I will ever forget the learnings from this video

    • @satish4426
      @satish4426 2 года назад +1

      Did u still remembered this formula ?

  • @SOPOkids
    @SOPOkids Год назад

    Sir apka padhaya poora samjh me aaya bahut accha laga it' s made me fan of you in Excel.
    Thankyou sir

  • @navyankakamath1541
    @navyankakamath1541 4 года назад +8

    Thank you so much sir...your classes are helping me a lot to learn excel in the proper way and gain some confidence🙏

  • @dikshabhadoria1828
    @dikshabhadoria1828 4 года назад

    Itni videos dekhi aaj tak kuch smjh nhi aaya and this video..ek baar m sab smjh aagya ...bht easy h.
    Sir please make video on pivot, how to prepare dashbord, index and match function.

  • @warisahmad8255
    @warisahmad8255 4 года назад +4

    I really love the way to teach.... Its became very easy for beginners like me to understand and perform on exel. But could u plz guide me how to download excel for free...

  • @sonalsuvankar104
    @sonalsuvankar104 2 года назад

    Thank you sir....my all doubts of vlookup are cleared and now I'm all set about vlookup

  • @snehbharoliya8137
    @snehbharoliya8137 5 лет назад +18

    Much awaited video of the whole excel series!!! Thank you so much sir!❤️

  • @AshishGupta-fy4rz
    @AshishGupta-fy4rz 3 года назад +1

    Maza aa gya. Awesome video. Thank you very very much sir ji

  • @prajnayjaiswal
    @prajnayjaiswal 5 лет назад +9

    Thank you so much sir for this video!
    A topic that I would like you to make a video on is Pivot Table.
    It plays a very important role in practical life.

  • @angelkapoor2848
    @angelkapoor2848 11 месяцев назад

    Excellent video sir...... only with in 2 or 3 minutes.. I am able to find my mistake... which I done in my excel sheet. Thanks for this video.

  • @mohdmisbah5845
    @mohdmisbah5845 3 года назад +5

    What a teacher🔥 i love the way you teach us🤗

  • @amitdewanjee1236
    @amitdewanjee1236 3 года назад +1

    Trust me, I learned a lot things from this video. Am really thankful to you.

  • @alphafusionn
    @alphafusionn 3 года назад +4

    Hello Sir,❤❤❤
    I really loved this class, easy, simple, and sorted. I want more helpful videos like this to crack excel.

  • @manjitsingh7756
    @manjitsingh7756 Год назад

    Great,,has been explained in a theroitical way,,,genuinely can't be founded on RUclips by another one same way of teaching.

  • @tusharvaswani8588
    @tusharvaswani8588 5 лет назад +7

    This is great package of excel , sir... love you

  • @mettleUnbeaten
    @mettleUnbeaten 2 года назад +1

    बहुत ही अच्छे से समझाया है आपने। धन्यवाद गुरु जी

  • @sbjnirmalstudio5326
    @sbjnirmalstudio5326 4 года назад +4

    Nicely presented and elaborated. Well done Indev . Keep it up 🌼🌼🌼

  • @RahulRathore-r2j
    @RahulRathore-r2j Год назад

    Your way of teaching is tremendous sir ji
    Today my all doubts are clear for vlookup
    Thanks a lot

  • @MrGarg-py3ul
    @MrGarg-py3ul 5 лет назад +4

    Sir are there some pen drive classes available for class 12 .... Sir i am a big fan of you ... Want to become a chartered accountant 😊

  • @hamidsiddiqui6452
    @hamidsiddiqui6452 4 года назад

    really Sir first time i tried to learn Excel nd by seeing your vlookup video you make excel as like ABCD awesome Sir

  • @kanchithakkar8471
    @kanchithakkar8471 4 года назад +1

    Thank you sir. This video made me v confident about v lookup function otherwise which I was dreadful about it over years. Thank you Sir🙌🏻. God Bless You.

  • @ram_88
    @ram_88 2 года назад +1

    At 29:43 I loved it....it's too funny and superb. Keep it up bro...comedy timing sense is awesome🤣🤣🤣🤣😂😂😂😂😅😅😅😅

  • @Sunny_zation
    @Sunny_zation Год назад +4

    Learning start from 3:58
    🙏🏻❤️

  • @mahrozrafique3916
    @mahrozrafique3916 Год назад

    Thankyou so much sir, I know I am too too too much late but seriously bohat faidha hu rah hai muje apki videos se... And I am learning excel from your page even lecture vise this was my the 4th lecture, Respect from Pakistan ❤🇵🇰 @excel for beginners

  • @ruhidewra9304
    @ruhidewra9304 4 года назад +3

    Sir I want all questions of excel for practice if it's available so pls revert me

  • @mohammadwasiuddin6579
    @mohammadwasiuddin6579 Год назад

    Really Appreciate your lecture, Training, and way of teaching, which are most important for all who want to grow & improve their life, especially VLOOKUP.

  • @bass_cassette
    @bass_cassette 4 года назад +3

    Thank you, explained in such a beautiful way. Easily understood 👍🏼

  • @Vidhirane92
    @Vidhirane92 3 года назад +1

    awesome explanation. till now i was always afraid of vlookup, but now you have made it so simple . Thanks a billion...

  • @yashkeshari17
    @yashkeshari17 5 лет назад +9

    Sir ITT me ap hi pdhana shuru krdijiye😉 satellite classes k through..

    • @CA-Nikhilsharma-10
      @CA-Nikhilsharma-10 5 лет назад

      Jab samne teacher padaa raha hota hai tab to bacche padte nahi hai satellite se to pad chuke 😂

  • @devranswal3726
    @devranswal3726 4 года назад

    Seriously sir I must say the way u explained I have never learned things so easy u made it so easy for me seriously hats off for your efforts keep up the good work, thanx once again.

  • @r.s6338
    @r.s6338 5 лет назад +7

    3:50 skip

  • @muhammadsaadali333
    @muhammadsaadali333 2 года назад

    I am from Pakistan and watching your video 1st time, your way of explaining every detail was excellent. I easily understood every point you mention in the video. 👍👍👍

  • @itrawadas1418
    @itrawadas1418 3 года назад +57

    Sir, please kaam ki baat jada kare.. likes subscribe ka marketing mat kijiye.. video useful hoga to apne aap like milenge...

  • @gauravjairamarya5625
    @gauravjairamarya5625 4 года назад

    ohhhh bhaii....... kya zhr sikhaya h apne....superb...great...great....great....

  • @kavitaverma9929
    @kavitaverma9929 3 года назад

    Just because of your one point that our column should be in the extreme left my formula got corrected otherwise I have 2-3 values but unable to apply the same . Thanks for sharing mistakes that we do while applying a formula.🙏
    Thanks sir

  • @kavikatoch8390
    @kavikatoch8390 Год назад

    It's a biggest co incedent is my husband name is CA Neeraj katoch unhone nahi sikhaya Excel kaha online sikho dekho naam and professiona is same sir seriously aap bahut ache se sikhate hai.

  • @aayushidixit3500
    @aayushidixit3500 2 года назад

    Very nice video on vlookup. Thank you sir for explaining vlookup in a very fabulous manner

  • @sandeeppandit4053
    @sandeeppandit4053 2 года назад

    Here is a short story about me just few minutes ego my Manager had given some work where I had to do some data segrigation. I was struggling badly then I saw this video and i completed the work. Thank you sir for this video. If anyone can describe Vlookup this was the most easiest one.

  • @YT_Shorts2712
    @YT_Shorts2712 2 года назад

    Realy , such m itne asan tarike s kisi n nhi samjaya

  • @arigo7697
    @arigo7697 5 месяцев назад

    U r really great sir, bohot hi majedar class thi… thankyou

  • @HarshSharma-ng2pu
    @HarshSharma-ng2pu 4 года назад

    Finally sir es video ko dekhne ke baad laga ki Vlookup easy hi
    Thank you so much sir

  • @rijomathew3310
    @rijomathew3310 3 года назад

    Sir, ur teaching is awesome, I watched my v-look up, this the No - 1

  • @priyavaibhav1129
    @priyavaibhav1129 Год назад

    Dear sir , thank you so very very very much sir
    it saved my 5 lakhs rupees due to recheck by your vlookup function, respect from heart!!

  • @waqarmuhammad2059
    @waqarmuhammad2059 2 года назад

    Thanks a million sir
    The best and easiest way I have ever experienced for Excel learning.

  • @ishitatiwari5972
    @ishitatiwari5972 2 года назад +1

    I found this channel very late but it's really helpful for me.... Thank You So much SIR for this wonderful explanation and guidance :)

  • @iq6715
    @iq6715 Год назад

    What an entertainment to learn vlookup, awesome! Thank you very much!! Mazza aa gaya bhai sahab!!

  • @ansariirfan3473
    @ansariirfan3473 4 года назад +1

    Thank you sir for sharing your awesome tutorial, you make us. Understand in a very easy way. Please keep sharing you videos

  • @GovindSharma-cr2vb
    @GovindSharma-cr2vb 4 года назад

    I am very thankful to you, Bahut hee funny and easy way mein aap ne samjhaya.

  • @AjayKumar-cz7xc
    @AjayKumar-cz7xc 2 года назад

    awesome class sir alot of people around me told that working on excel is so much tough but when I start learning it from you I lov it :)

  • @bittukumarsharma5395
    @bittukumarsharma5395 2 года назад

    Sach me sir mane Vlookup ka vidio dekha but apki bat hi alag ha thanks

  • @sumansingh1266
    @sumansingh1266 3 года назад

    Thanks sir , vlookup samjhne ke liye , aaj se pehle bhot confusion hota h formula bhul jate the but ab nhi bulenge

  • @sharadchavan6021
    @sharadchavan6021 Год назад

    Very nice & useful video to everyone sir. Great work done by you. Thank you soooooo much sir

  • @MehfilESukhen
    @MehfilESukhen 2 года назад

    I used this method in data with thousand entry, n it work great in that. Thank you 🙏

  • @pankajcharola5524
    @pankajcharola5524 11 месяцев назад

    Dude You are The Great 👏
    No one else could have taught me this better than you, Thanks a ton 👍
    Jai Hind 🕉️🇮🇳

  • @Ashish_yadav17
    @Ashish_yadav17 4 года назад

    Ksm se Shaab kya smjhaya hai aapne....
    You are great brother. I was understing very difficult to vlookup.
    But not now😊
    Thanks again bhai shaab💓

  • @everywhere6989
    @everywhere6989 4 года назад

    Mind blowing sir
    Doubt
    Sir vlookup approx match mein dekho apke values right corner mein hai apne bola tha left mein honge to value ayegi.. To right mein kaise..?

  • @Accountant_In
    @Accountant_In Год назад

    now i realized, why freezing is compulsory! Thank you for this video sir!

  • @simplecookingwithnidhi8993
    @simplecookingwithnidhi8993 2 года назад

    very informative video i searched on many channel but the way you explained 3-4 time in different manner was amazing.
    would also like to know how to make invoice in excel if already shared please share the link it is very important for me.

  • @be_happy027
    @be_happy027 2 года назад +1

    Superb dear sir ji i like it... really fixed for long time in my mind i am never forget this formula and your explanation is very very excellent.. thank you sir ji...🙏🙏🙏

  • @akashkhadah
    @akashkhadah 2 года назад

    love this video got to understand it well. but when u explain it maybe u forgot to say put , (coma) when u put the formula. the explaination is superb. understand it completely

  • @pragatikumari8936
    @pragatikumari8936 4 года назад

    Thanks sir itna a6e se samjhane k liye... Or practice karungi agr ku6 ni ayega comment karungi plz use smjha dijiyega apki bht bht maherbani hogi

  • @harendrasrivastava5719
    @harendrasrivastava5719 4 года назад

    Really Sir Amazing Video especially sir you point the mistake which we usually done during using vlookup formula.....

  • @tufailfayaz3629
    @tufailfayaz3629 2 года назад

    29:43 pai to maza hi aagaya.......luv u sir

  • @maheshshaw6150
    @maheshshaw6150 3 года назад

    Finally i have understand the concept, after watching this video

  • @DipuGupta-eu7ps
    @DipuGupta-eu7ps 5 месяцев назад

    Practical krke bataya bahut acha kiya or kafi details se bataya

  • @basantakumarbhuyan2558
    @basantakumarbhuyan2558 Год назад

    I learnt very easily of VLOOKUP Excel formula....
    Thanks Sir.... For your teaching 🙏🙏

  • @ShahFaisal-fs4wu
    @ShahFaisal-fs4wu 2 года назад

    EXCELENT WAY OF EXPALANATION Thanks for sharing your knowledge

  • @mandeepsandhi3397
    @mandeepsandhi3397 Год назад

    Great teacher of Excel God bless you sir .. thank you

  • @shaileshdubey1551
    @shaileshdubey1551 3 года назад +1

    This is the best video for learning vlookup in the world .... The video is too much interesting......... *Sir I request you to teach whole advance excel with formulas..............*

  • @newcreationofpoetry5412
    @newcreationofpoetry5412 4 года назад

    Aap ka tareeka kafi achha lga or bor bhi bilkul bhi nhi huaa thank u so much

  • @jamyangtschodar2062
    @jamyangtschodar2062 3 года назад

    Wah Sir, 👏🏻👏🏻👏🏻 Kay Baat hai.
    Thank you 🙏🏻 so much

  • @thingepurekaanchho
    @thingepurekaanchho Год назад

    Its me loving this channel from Nepal.❤
    Very Nice teaching.
    And also i am saving around Rs 3000 for pursuing this through any excel teaching institute

  • @nevilledsouza1412
    @nevilledsouza1412 4 года назад +1

    Sir, very easy to understand, nicely explained, and humorous too which is nice for the learning process.

  • @fahadkagotia6561
    @fahadkagotia6561 4 года назад

    You are an Excellent Teacher on RUclips. It is very important for every student to learn from you. I like your Teaching video. Excellent training method.

  • @paraskhurana1608
    @paraskhurana1608 4 года назад

    Brilliant Neeraj sir . you made this program very easy. Thanks for your support.